package com.kx.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kx.vo.GoodBarVO;
import com.kx.entity.Goods;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GoodsMapper extends BaseMapper<Goods> {
    @Select("select name,count(categorylevelone_id) count from goods,goods_category where categorylevelone_id=id group by categorylevelone_id;")
    List<GoodBarVO> findAllGoodBarVO();
}
